UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ThP+yMqwpD9ZpPCzTpLTh2IX97VDY6B/r9+jKMRc5/A='
WHERE
key_id = '0220219c94f7e907edb9ff4d7f94e9d15573739f10e6a4f0e550cd7ec30ecbe9'
AND (
token = 'ThP+yMqwpD9ZpPCzTpLTh2IX97VDY6B/r9+jKMRc5/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)