UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NKhdw1JGHbsVJgwRuuOIlJyt8SUwepFDaO1Qsz5wC0='
WHERE
key_id = 'e19e755cab904099e7937dff9602e67718ffe341b4d3f34660c997b78d6e8404'
AND (
token = '7NKhdw1JGHbsVJgwRuuOIlJyt8SUwepFDaO1Qsz5wC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)