UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tAuBs98bIMX1B7OEFmONWAuF4YFiVWfEPGr+XyAThyA='
WHERE
key_id = '0f6d5913cee9b21c57b176b60bd05fd42e72399d314cc575fdde2c925c8de042'
AND (
token = 'tAuBs98bIMX1B7OEFmONWAuF4YFiVWfEPGr+XyAThyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)