UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vIwTNWVklROxBzh5QBGC9ei75dD+shOJ07lV1Q7tSL4='
WHERE
key_id = 'ad648ab49715049b9c149b0100b534f23548445b6b341dcc1f69bf11a6d93172'
AND (
token = 'vIwTNWVklROxBzh5QBGC9ei75dD+shOJ07lV1Q7tSL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)