UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDwe4zz1t0h+nOejEtDVC8ovIhBzOZZBoc66KGPC0Lk='
WHERE
key_id = '540b4e0e0551ec8d71ac8dbb22ad116ed41aed0e4994a0995a3df7a0a5dcef82'
AND (
token = 'ZDwe4zz1t0h+nOejEtDVC8ovIhBzOZZBoc66KGPC0Lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)