UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6qKLmigKXW8dnVGeo/rGxkAtiP28Zps4gx7ZXDQ1Zk='
WHERE
key_id = '27a7a41ce58dd176d91a3954f579f6c4539c1e35a13722b03f943564688875c9'
AND (
token = 'N6qKLmigKXW8dnVGeo/rGxkAtiP28Zps4gx7ZXDQ1Zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)