UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hiPb1C+I8GMdSt+PBjfZ1V53KzmXcJBreS3y3Z/YgYU='
WHERE
key_id = 'f8762ce765b1a9ffe725ea97e27cf84b4f1484e4db7fbd732776129c68ac79ab'
AND (
token = 'hiPb1C+I8GMdSt+PBjfZ1V53KzmXcJBreS3y3Z/YgYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)