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