UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lEQ8psKJI9wogtna6ay53q/679y3YgYwzsraNURZmIo='
WHERE
key_id = 'c9a8becc289b8620ffd107740297083ef1d903ae6193b5106a19a794a948d642'
AND (
token = 'lEQ8psKJI9wogtna6ay53q/679y3YgYwzsraNURZmIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)