UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2thUagIbq8fAfMLAbVIbThrQqQaUJ4cwzgCE1cRAN04='
WHERE
key_id = 'af7804eb202af070cd6bb84833d50c797f889f9c75ac8a6648698ce34ac2dfd0'
AND (
token = '2thUagIbq8fAfMLAbVIbThrQqQaUJ4cwzgCE1cRAN04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)