UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHpu20JjunKaVy16ACAIEdh85ACE2jt/MLa7rhkL5QU='
WHERE
key_id = '0816773e535e325b56c0d5c83f565c7528a800483debd8864a96b5dd1385f2d7'
AND (
token = 'zHpu20JjunKaVy16ACAIEdh85ACE2jt/MLa7rhkL5QU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)