UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bk+9J6a9YicgdGO03ffdUVBi599Zk4UUY17w5z998fw='
WHERE
key_id = '77ecd98f011e7d56abcef2d02dc1ca786b67da7af5b7976a0bc2a2ec27e14216'
AND (
token = 'Bk+9J6a9YicgdGO03ffdUVBi599Zk4UUY17w5z998fw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)