UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BW967Y5GK5A35Ror5Bz0hytiKaRKvPzNn92GIrItDcQ='
WHERE
key_id = '6b8db42c6e70b733ec67d79918ae0925efaee9760100f83972e450301c97b0e7'
AND (
token = 'BW967Y5GK5A35Ror5Bz0hytiKaRKvPzNn92GIrItDcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)