UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHL2J/UvA8vHPXp5vlCpKqle15y1WgyWlvW0S85LqNM='
WHERE
key_id = 'e00434c236ae3ceabeae966fd809fe081df9bc428f64db8b93f2e74d9b975438'
AND (
token = 'xHL2J/UvA8vHPXp5vlCpKqle15y1WgyWlvW0S85LqNM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)