UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dI3n4tr5y+zlAogJcR27QAY0f7MgKgwMI2Dtd+8J470='
WHERE
key_id = '7ac723101f9536e058a9a2ebe1b3e239c2777c2cb4773008b6396213d12a37dd'
AND (
token = 'dI3n4tr5y+zlAogJcR27QAY0f7MgKgwMI2Dtd+8J470='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)