UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nCGuHVATZXLvM/MVFO++VcRjH+AonzcCphyZ0j1JYOw='
WHERE
key_id = 'e809eea3fdab720243b603727c80c67ca98e677ffb0cd06e57e4e9aff12da81b'
AND (
token = 'nCGuHVATZXLvM/MVFO++VcRjH+AonzcCphyZ0j1JYOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)