UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rkSAxaHgNfPLcRamt1Yqo23/RNdj/8N88sYXrru/g1c='
WHERE
key_id = 'd8586b3b994a786e3e7af7cac2c06de5b1a6e2d149ae5323db5ef7743a3b9aff'
AND (
token = 'rkSAxaHgNfPLcRamt1Yqo23/RNdj/8N88sYXrru/g1c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)