UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oilgv+7tAnFQfdVifw00/b5LVq6+X8i0JHSFJT1N5vg='
WHERE
key_id = '27ac4e4d64b036f6cd803d47230abb7d191afb726664a362257617cf60103c03'
AND (
token = 'oilgv+7tAnFQfdVifw00/b5LVq6+X8i0JHSFJT1N5vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)