UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZP65N1N3KkS9uxnCr7IcJCbXwXTylq5RK48QDqyW1w0='
WHERE
key_id = '8c31d87fbe00acbe0fe77ead57da1fedfef68c73ea4148ba15fce27f3e0968ee'
AND (
token = 'ZP65N1N3KkS9uxnCr7IcJCbXwXTylq5RK48QDqyW1w0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)