UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6xPaYGSnX0I9UK3xvBtWF5cROP21/qmm87tc3dSRUk='
WHERE
key_id = '781345e826503f27bc76fe32982c8b967b57bc29190ea6dcfec15287732f6dc5'
AND (
token = 'r6xPaYGSnX0I9UK3xvBtWF5cROP21/qmm87tc3dSRUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)