UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SxGZn3X8Nh+rtJn5Rh3nHn1SVCyV9FCCw17oooQ1mY='
WHERE
key_id = '557c1d971ceb8c87545029fa73f549e2f034ae55779538a4aef1bc98514375e9'
AND (
token = '8SxGZn3X8Nh+rtJn5Rh3nHn1SVCyV9FCCw17oooQ1mY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)