UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pDTQoISYloGoK8HYOgqhH7+94JL8Sgg55ACE5wssIqA='
WHERE
key_id = '2a598a4137f50b0ef4695e257b988c26c0e66f32ae966de9e581a43692d3aa4c'
AND (
token = 'pDTQoISYloGoK8HYOgqhH7+94JL8Sgg55ACE5wssIqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)