UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'crVTTZT+xlt7gXiR/dCPTg3RKaBXvHK7+22UQZI93oU='
WHERE
key_id = '5f619861c520d67e9b425235426aaacb2924c3d6dda8cb29a09d8cd5cbe4ec4c'
AND (
token = 'crVTTZT+xlt7gXiR/dCPTg3RKaBXvHK7+22UQZI93oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)