UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DG8Rzuv4JVAZmEUNI4nkHprKBj86t0LP5wU8qRZIhm4='
WHERE
key_id = 'a324a6fbf2f9ae31e2e2a0cfa5101cd58746f6fc815e5a68a86619e1ba4a34f2'
AND (
token = 'DG8Rzuv4JVAZmEUNI4nkHprKBj86t0LP5wU8qRZIhm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)