UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qKcyPhLGABmDinNt3gg6QYGrCR1lE20H80PT2Ats/n0='
WHERE
key_id = '1d7a69e8d5d996bd37ddab4cd589176bb4c4147611adf661fe02f332694f9c8c'
AND (
token = 'qKcyPhLGABmDinNt3gg6QYGrCR1lE20H80PT2Ats/n0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)