UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CcNfnRXyXlWsNHJVkDR/TsAGfcn+c9FkDaEHCoB8YCg='
WHERE
key_id = 'd579f3e2607cfc9b905f6dedf80766cd212b881747018e22f1932f7c72452513'
AND (
token = 'CcNfnRXyXlWsNHJVkDR/TsAGfcn+c9FkDaEHCoB8YCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)