UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cPAh67Fe+ua2zRM+WkxXHh7FrQvI+XPMVnuSSnGRSTo='
WHERE
key_id = 'd506d12bcb7b09e1ce70984bfd3d429e0de6317c10186d3ff89de4a638209e32'
AND (
token = 'cPAh67Fe+ua2zRM+WkxXHh7FrQvI+XPMVnuSSnGRSTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)