UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LkfQ9mnXnYq92w2GV1NyENKdmpE4oWdaVdsZZXHipu8='
WHERE
key_id = '3a55c964975a1fa980741296d0a9935b19a49688ddc01b9d0a4b82deb55b10d1'
AND (
token = 'LkfQ9mnXnYq92w2GV1NyENKdmpE4oWdaVdsZZXHipu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)