UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D0XtqOcvcgclUwYlboabQ5gjj4Vc01/ZOxnnqJ3Y8XA='
WHERE
key_id = '6e59c9f4f43fa4d835fb8a26228055e8995facd87e715abc2a1e914980babe0c'
AND (
token = 'D0XtqOcvcgclUwYlboabQ5gjj4Vc01/ZOxnnqJ3Y8XA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)