UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Iw+eev6XncYw/UjQOyLP6HoI5OmfsKKKYiaqBvk/x8='
WHERE
key_id = '01e16573253e235e889093b2ac9e933c4c194d688873a0aeea786594feaa65ca'
AND (
token = '6Iw+eev6XncYw/UjQOyLP6HoI5OmfsKKKYiaqBvk/x8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)