UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oC6DBpR2qqnUFwbOhnhEZzUWY3580mFT8wLj+v/eSA8='
WHERE
key_id = '793457ec3bc414296c8f2559226702c65205b016451412cf508fe69e23e7f552'
AND (
token = 'oC6DBpR2qqnUFwbOhnhEZzUWY3580mFT8wLj+v/eSA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)