UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BbXdgZUqQ3cGk6jmNBAjmc+huse090Q6bcjb/W8CFO8='
WHERE
key_id = '7970c13294dcb09d4904b7312d7247b998b3c843663c050675bc18b2fc4ad278'
AND (
token = 'BbXdgZUqQ3cGk6jmNBAjmc+huse090Q6bcjb/W8CFO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)